home *** CD-ROM | disk | FTP | other *** search
/ mail.altrad.com / 2015.02.mail.altrad.com.tar / mail.altrad.com / TEST / office deutch / ACCESS.NL-NL / ACCLR.CAB / ACCESS_TEMPLATE_SALESPIPELINE.ACCDT_1043 / template / database / objects / queryCustomersExtendedAddFurigana.txt < prev    next >
Text File  |  2006-11-12  |  5KB  |  112 lines
  1. ∩╗┐Operation =1
  2. Option =0
  3. Begin InputTables
  4.     Name ="Customers"
  5. End
  6. Begin OutputColumns
  7.     Alias ="File As"
  8.     Expression ="IIf(IsNull([Last Name Furigana]),IIf(IsNull([First Name Furigana]),[Company Furigana],[First Name Furigana]),IIf(IsNull([First Name Furigana]),[Last Name Furigana],[Last Name Furigana] & \" \" & [First Name Furigana]))"
  9.     Alias ="Contact Name"
  10.     Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
  11.     Expression ="Customers.*"
  12. End
  13. Begin OrderBy
  14.     Expression ="IIf(IsNull([Last Name Furigana]),IIf(IsNull([First Name Furigana]),[Company Furigana],[First Name Furigana]),IIf(IsNull([First Name Furigana]),[Last Name Furigana],[Last Name Furigana] & \" \" & [First Name Furigana]))"
  15.     Flag =0
  16.     Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
  17.     Flag =0
  18. End
  19. dbBoolean "ReturnsRecords" ="-1"
  20. dbInteger "ODBCTimeout" ="60"
  21. dbByte "RecordsetType" ="0"
  22. dbBoolean "OrderByOn" ="0"
  23. dbByte "Orientation" ="0"
  24. dbByte "DefaultView" ="2"
  25. dbBoolean "FilterOnLoad" ="0"
  26. dbBoolean "OrderByOnLoad" ="-1"
  27. dbBoolean "TotalsRow" ="0"
  28. dbBinary "GUID" = Begin
  29.     0x7233de6d5919c2438b87550d8a7eadfd
  30. End
  31. dbLongBinary "DOL" = Begin
  32.     0x0acc0e5500000000235aaf10707214419ebd512cf4e2e3a800000000ae9675f4 ,
  33.     0x570ae340010000004029283443007500730074006f006d006500720073000000 ,
  34.     0x00000000932cc9c2567d2744be3cd96afe95a628070000007233de6d5919c243 ,
  35.     0x8b87550d8a7eadfd460069006c00650020004100730000000000000065e7a973 ,
  36.     0x69bcc04fbf9789799fc10c22070000007233de6d5919c2438b87550d8a7eadfd ,
  37.     0x43006f006e00740061006300740020004e0061006d006500000000000000fee7 ,
  38.     0x1c61aaa1ea4b914a720f56349c9707000000235aaf10707214419ebd512cf4e2 ,
  39.     0xe3a84c0061007300740020004e0061006d00650000000000000075b48e87031a ,
  40.     0x744c8ee79b351e3caaa607000000235aaf10707214419ebd512cf4e2e3a84600 ,
  41.     0x690072007300740020004e0061006d006500000000000000698fb472ec924149 ,
  42.     0xa6a0a58fbd19947307000000235aaf10707214419ebd512cf4e2e3a843006f00 ,
  43.     0x6d00700061006e00790000000000000000000000000000000000000000000000 ,
  44.     0x0c000000040000000000000000000000000000000000 ,
  45.     0x0acc0e5500000000235aaf10707214419ebd512cf4e2e3a8000000005e7b8def ,
  46.     0x570ae340010000004029283443007500730074006f006d006500720073000000 ,
  47.     0x00000000ba09b84af4267d4aa62e71780652b0520700000000cb7b977e82194f ,
  48.     0x916bf606d1e0f24a460069006c006500200041007300000000000000439c3bac ,
  49.     0x9db6484094913c3dfe48569a0700000000cb7b977e82194f916bf606d1e0f24a ,
  50.     0x43006f006e00740061006300740020004e0061006d006500000000000000fbeb ,
  51.     0x941cd13c664b86305ca1e1557f6b07000000235aaf10707214419ebd512cf4e2 ,
  52.     0xe3a84c0061007300740020004e0061006d006500200046007500720069006700 ,
  53.     0x61006e0061000000000000004f3e4e2af69f0c4792a1b2bfcc2aa80f07000000 ,
  54.     0x235aaf10707214419ebd512cf4e2e3a84600690072007300740020004e006100 ,
  55.     0x6d00650020004600750072006900670061006e006100000000000000556276c5 ,
  56.     0x710aa142bb7b03d398f5746407000000235aaf10707214419ebd512cf4e2e3a8 ,
  57.     0x43006f006d00700061006e00790020004600750072006900670061006e006100 ,
  58.     0x000000000000fee71c61aaa1ea4b914a720f56349c9707000000235aaf107072 ,
  59.     0x14419ebd512cf4e2e3a84c0061007300740020004e0061006d00650000000000 ,
  60.     0x000075b48e87031a744c8ee79b351e3caaa607000000235aaf10707214419ebd ,
  61.     0x512cf4e2e3a84600690072007300740020004e0061006d006500000000000000 ,
  62.     0x698fb472ec924149a6a0a58fbd19947307000000235aaf10707214419ebd512c ,
  63.     0xf4e2e3a843006f006d00700061006e0079000000000000000000000000000000 ,
  64.     0x00000000000000000c000000040000000000000000000000000000000000
  65. End
  66. Begin
  67.     Begin
  68.         dbText "Name" ="Contact Name"
  69.         dbInteger "ColumnWidth" ="1695"
  70.         dbInteger "ColumnOrder" ="1"
  71.         dbBoolean "ColumnHidden" ="0"
  72.         dbMemo "SmartTags" ="\"urn:schemas-microsoft-com:office:smarttags#PersonName\""
  73.         dbLong "AggregateType" ="-1"
  74.         dbBinary "GUID" = Begin
  75.             0x65e7a97369bcc04fbf9789799fc10c22
  76.         End
  77.     End
  78.     Begin
  79.         dbText "Name" ="File As"
  80.         dbInteger "ColumnWidth" ="1695"
  81.         dbInteger "ColumnOrder" ="2"
  82.         dbBoolean "ColumnHidden" ="0"
  83.         dbLong "AggregateType" ="-1"
  84.         dbBinary "GUID" = Begin
  85.             0x932cc9c2567d2744be3cd96afe95a628
  86.         End
  87.     End
  88. End
  89. Begin
  90.     State =0
  91.     Left =0
  92.     Top =0
  93.     Right =799
  94.     Bottom =612
  95.     Left =-1
  96.     Top =-1
  97.     Right =784
  98.     Bottom =268
  99.     Left =0
  100.     Top =0
  101.     ColumnsShown =539
  102.     Begin
  103.         Left =48
  104.         Top =12
  105.         Right =192
  106.         Bottom =156
  107.         Top =0
  108.         Name ="Customers"
  109.         Name =""
  110.     End
  111. End
  112.